AdEnroll

Logical Entity Name | AdEnroll
Default Table Name | AdEnroll
Physical Only | NO
Owner | dbo
Definition |
Note |

AdEnroll Columns

ColumnName | Domain | Datatype | NULL | Definition
SyStudentID |  | int | NO |
StuNum |  | nvarchar(30) | NO |
AppRecDate |  | datetime | YES |
EnrollDate |  | datetime | YES |
StartDate |  | datetime | YES |
ExpStartDate |  | datetime | YES |
ReEntryDate |  | datetime | YES |
GradDate |  | datetime | YES |
MidDate |  | datetime | YES |
FaExitDate |  | datetime | YES |
LDA |  | datetime | YES |
StatusDate |  | datetime | YES |
AmRepID |  | int | NO |
SyCampusID |  | int | NO |
SySchoolStatusID |  | int | NO |
AdGradeLevelID |  | int | NO |
GPA |  | numeric(11, 6) | NO |
CoreGPA |  | numeric(11, 6) | YES |
NumAvg |  | numeric(11, 6) | NO |
CoreNumAvg |  | numeric(11, 6) | YES |
MinutesAttended |  | money | YES |
HoursAttempt |  | numeric(9, 2) | NO |
HoursEarned |  | numeric(9, 2) | NO |
CreditsAttempt |  | money | NO |
CreditsEarned |  | money | NO |
CoreCreditsAttempt |  | money | YES |
CoreCreditsEarned |  | money | YES |
HoursReq |  | money | NO |
CreditsReq |  | money | NO |
HoursSched |  | money | NO |
CreditsSched |  | money | NO |
MinutesAbsent |  | int | YES |
MinutesMakeUp |  | int | YES |
DaysAbsent |  | money | NO |
adTermID |  | int | YES |
adAttStatID |  | int | NO |
adShiftID |  | int | NO |
adProgramDescrip |  | nvarchar(150) | YES |
adProgramVersionID |  | int | NO |
TransferInDate |  | datetime | YES |
DegreeAudit |  | char(6) | NO |
SAP |  | char(1) | NO |
SaBillingMethodID |  | int | YES |
DateBilled |  | datetime | YES |
ARBalance |  | money | NO |
adGradeScaleID |  | int | NO |
DropEarn |  | money | NO |
Comment |  | varchar(255) | NO |
ModFlag |  | char(1) | NO |
TranscriptIssue |  | datetime | YES |
Userid |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdEnrollID |  | int | NO |
AdAdvisorID |  | int | YES |
AdReasonID |  | int | YES |
CumGPAPoints |  | money | YES |
GPACredits |  | money | YES |
ExternBeginDate |  | datetime | YES |
QTExport |  | bit | YES |
AdSapStatusID |  | int | YES |
DropDate |  | datetime | YES |
FaEntrDate |  | datetime | YES |
Transfer |  | bit | NO |
PrevGradDate |  | datetime | YES |
RightsResponsibilitiesAck |  | bit | NO |
DropType |  | char(1) | YES |
IPEDSState |  | char(2) | NO |
ExpectedRefundProcessDate |  | datetime | YES |
AttendanceArchived |  | bit | NO |
OrigGradDate |  | datetime | YES |
AdProgramID |  | int | YES |
AdStartDateID |  | int | YES |
LastActivityDate |  | datetime | YES |
AmZoneID |  | int | YES |
AmApplicantTypeID |  | int | YES |
OriginalAmRepID |  | int | YES |
Applicant |  | bit | NO |
ApplicantProgress |  | int | NO |
AdCatalogYearID |  | int | YES |
OriginalExpStartDate |  | datetime | YES |
IPEDSTransfer |  | bit | NO |
ExpectedCreditsPerTerm |  | numeric(7, 2) | NO |
ExpectedHoursPerWeekForExternship |  | numeric(9, 2) | NO |
SAPCheckpoint |  | tinyint | NO |
RecalculateTermSequence |  | bit | NO |
LinkedSAPEnrollId |  | int | YES |
NSLDSWithdrawalDate |  | datetime | YES |
ReEntry |  | tinyint | NO |
CrmSuppressFlag |  | bit | NO |
TransferCredits |  | money | YES |
StatChangeType |  | int | NO |
amPrevEducID |  | int | NO |
ReentryAfter180 |  | datetime | YES |
SPEProgression |  | money | YES |
IsUIUpdate |  | bit | NO |
AOSTransferDate |  | datetime | YES |
OutsideCourseWorkHours |  | numeric(9, 2) | NO |
FaCredits |  | numeric(9, 2) | NO |
AutoChargesTermID |  | int | YES |
FAAttStatID |  | int | NO |
NoOfCategoriesMFApplied |  | int | NO |

AdEnroll Primary and Unique Keys

Key Name | Key Type | Keys
AdEnroll_SyStudentId_SyCampusId_AdProgramVersionId_AdEnrollId_U_N_IDX | Index | SyStudentID, SyCampusID, adProgramVersionID, AdEnrollID
AdEnroll_adProVerID_SyCamID_SaBilMetId_SySchStaId_CreReq_HouReq_AdShiId_DatBil_ExpStaDat_GraDat_AdEnrID_U_N_IDX | Index | adProgramVersionID, SyCampusID, SaBillingMethodID, SySchoolStatusID, CreditsReq, HoursReq, adShiftID, DateBilled, ExpStartDate, GradDate, AdEnrollID
AdEnroll_AdEnrollID_U_C_IDX | PrimaryKey | AdEnrollID
AdEnroll_SyCampusID_SaBillingMethodID_AdEnrollID_U_IDX | Index | SyCampusID, SaBillingMethodID, AdEnrollID
Uk_AdEnrollLinkedSAPEnrollID_AdEnrollAdEnrollID | Index | LinkedSAPEnrollId, AdEnrollID

AdEnroll Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdCatalogYear | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AdCatalogYearID_AdCatalogYear_AdCatalogYearID |  |  | AdCatalogYearID | NO | YES
AdProgram | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AdProgramID_AdProgram_AdProgramID |  |  | AdProgramID | NO | YES
AdProgramVersion | Non-Identifying | One To Zero or More | FK_AdEnroll_adProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  | adProgramVersionID | NO | YES
AdStartDate | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AdStartDateID_AdStartDate_AdStartDateID |  |  | AdStartDateID | NO | YES
AmApplicantType | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_AmApplicantTypeID_AmApplicantType_AmApplicantTypeID |  |  | AmApplicantTypeID | NO | YES
syState | Non-Identifying | One To Zero or More | FK_AdEnroll_IPEDSState_syState_code |  |  | IPEDSState | NO | YES
AdEnroll | Non-Identifying | Zero or One to Zero or More | FK_AdEnroll_LinkedAdEnrollId_AdEnrollId |  |  | LinkedSAPEnrollId | NO | YES
SySchoolStatus | Non-Identifying | One To Zero or More | FK_AdEnroll_SySchoolStatusID_SySchoolStatus_SySchoolStatusID |  |  | SySchoolStatusID | NO | YES
syStudent | Non-Identifying | One To Zero or More | FK_AdEnroll_SyStudentID_syStudent_SyStudentID |  |  | SyStudentID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdEnrollTermConfirm | Non-Identifying | One To Zero or More | AdEnrollTermConfirm_AdEnrollId_AdEnroll_AdEnrollId |  |  |  | NO | YES
AdApplicationExternalMap | Non-Identifying | One To Zero or More | FK_AdApplicationExternalMap_AdEnrollId_AdEnrollAdEnrollID |  |  |  | NO | YES
AdConcentrationByEnrollment | Non-Identifying | Zero or One to Zero or More | FK_AdConcentrationByEnrollment_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdDegreeAuditUnmatchedTakenCourse | Non-Identifying | One To Zero or More | FK_AdDegreeAuditUnmatchedTakenCourseAdEnrollId_AdEnrollAdEnrollId |  |  |  | NO | YES
AdEnroll | Non-Identifying | One To Zero or More | FK_AdEnroll_LinkedAdEnrollId_AdEnrollId |  |  |  | NO | YES
AdEnrollBook | Non-Identifying | One To Zero or More | FK_AdEnrollBook_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollDegreeAuditCourse | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditCourse_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollDegreeAuditCourseCategory | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditCourseCategory_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollDegreeAuditFulfillment | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollDegreeAuditFulfillment_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollDegreeAuditRequirementRule | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditRequirementRule_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollExternalMap | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollExternalMap_AdEnrollId_AdEnroll_AdEnrollId |  |  |  | NO | YES
AdEnrollExternalMap | Non-Identifying | One To Zero or More | FK_adEnrollExternalMapadEnrollId_adEnrolladEnrollId |  |  |  | NO | YES
AdEnrollHonors | Non-Identifying | One To Zero or More | FK_AdEnrollHonors.AdEnrollID_AdEnroll.AdEnrollID |  |  |  | NO | YES
AdEnrollNonTermBreakInfo | Non-Identifying | One To Zero or More | FK_AdEnrollNonTermBreakInfoAdEnrollID_AdEnrollAdEnrollID |  |  |  | NO | YES
AdEnrollRegistration | Non-Identifying | One To Zero or More | FK_AdEnrollRegistration_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollRegistrationGroup | Non-Identifying | One To Zero or More | FK_AdEnrollRegistrationGroup_AdEnrollID_AdEnroll_AdEnroll |  |  |  | NO | YES
AdEnrollRegTerm | Non-Identifying | One To Zero or More | fk_AdEnrollRegTerm_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollSched | Non-Identifying | One To Zero or More | FK_AdEnrollSched_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollSchedOtherEnroll | Non-Identifying | One To Zero or More | FK_AdEnrollSchedOtherEnroll_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollSchedStatusHistory | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSchedStatusHistory_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollTerm | Non-Identifying | One To Zero or More | FK_AdEnrollTerm_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollTerm_RebuildRelationshipLog | Non-Identifying | One To Zero or More | FK_AdEnrollTerm_RebuildRelationshipLog_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdEnrollTermRelationshipException | Non-Identifying | One To Zero or More | FK_AdEnrollTermRelationshipException_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdFees | Non-Identifying | One To Zero or More | FK_AdFees_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdSapQueue_Detail | Non-Identifying | One To Zero or More | FK_AdSapQueue_Detail_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdSapQueue_Detail | Non-Identifying | Zero or One to Zero or More | FK_AdSapQueue_Detail_LinkedAdEnrollId_AdEnrollId |  |  |  | NO | YES
AdSPECourseCategory | Non-Identifying | One To Zero or More | FK_AdSPECourseCategory_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdStudentDegreePathway | Non-Identifying | One To Zero or More | FK_AdStudentDegreePathway_AdEnrollId_AdEnroll_AdEnrollId |  |  |  | NO | YES
AdStudentTermSequenceHeader | Non-Identifying | One To Zero or More | FK_AdStudentTermSequenceHeader_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_FromAdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_ToAdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AmCollegeTransferAdvance | Non-Identifying | One To Zero or More | FK_AmCollegeTransferAdvance_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
AmEnrollApplication | Non-Identifying | One To Zero or More | FK_AmEnrollApplication_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
FaCampusVantageWorkStudyPayroll | Non-Identifying | One To Zero or More | FK_FaCampusVantageWorkStudyPayroll_AdEnrollID_AdEnroll_AdEnrollId |  |  |  | NO | YES
FaCodActualDisb_REG | Non-Identifying | One To Zero or More | FK_FaCodActualDisb_REGAdEnrollId_AdEnroll_AdEnrollId |  |  |  | NO | YES
FaIntersessionTermRegistration | Non-Identifying | One To Zero or More | FK_FaIntersessionTermRegistration_AdEnrollId_AdEnroll_AdEnrollId |  |  |  | NO | YES
FaNSLDSStudent | Non-Identifying | One To Zero or More | FK_FaNSLDSStudent_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanHistory_AdEnroll_AdEnrollId |  |  |  | NO | YES
FaStudentAY | Non-Identifying | One To Zero or More | FK_FaStudentAY_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
FaStudentFundSource | Non-Identifying | One To Zero or More | FK_FaStudentFundSourceAdEnrollId_AdEnrollAdEnrollId |  |  |  | NO | YES
FaStudentLoanPeriod | Non-Identifying | One To Zero or More | FK_FaStudentLoanPeriod_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
HSStudentLeaseHistory | Non-Identifying | One To Zero or More | FK_HsStudentLeaseHistoryAdEnrollID_AdEnrollAdEnrollID |  |  |  | NO | YES
PlReasonQuestionAnswer | Non-Identifying | One To Zero or More | FK_PlReasonQuestionAnswer_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
PlReasonQuestionAnswerResponseComment | Non-Identifying | One To Zero or More | FK_PlReasonQuestionAnswerResponseComment_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
RecalculateBudgetQueue | Non-Identifying | One To Zero or More | FK_RecalculateBudgetQueue_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetail_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaBillingStatementBatchDetailCharges | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchDetailCharges_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaBillingStatementBatchDetailFA | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchDetailFA_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaBillingStatementBatchDetailPayments | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchDetailPayments_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaBillingStatementBatchStudent | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchStudent_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaBillingStatementBatchSubsidiaryDetail | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchSubsidiaryDetail_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaCollectionAccountStatus | Non-Identifying | One To Zero or More | FK_SaCollectionAccountStatus_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaCollections | Non-Identifying | One To Zero or More | FK_SaCollections_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaEnrollAcctStatus | Non-Identifying | One To Zero or More | FK_SaEnrollAcctStatus_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaEnrollRevenueChildTerm | Non-Identifying | One To Zero or More | FK_SaEnrollRevenueChildTerm_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaPendingChargeCourseAmount | Non-Identifying | One To Zero or More | FK_SaPendingChargeCourseAmount_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaPendingChargeDetail | Non-Identifying | One To Zero or More | FK_saPendingChargeDetail.AdEnrollID_AdEnroll.AdEnrollID |  |  |  | NO | YES
SaRegBillQueue_Detail | Non-Identifying | One To Zero or More | FK_SaRegBillQueue_Detail_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaStatementHistory | Non-Identifying | One To Zero or More | FK_SaStatementHistory_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaStudentLedgerTermUpdatesArchive | Non-Identifying | One To Zero or More | FK_SaStudentLedgerTermUpdatesArchive_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaStudSubsidiary | Non-Identifying | One To Zero or More | Fk_SaStudSubsidiary_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaStudSubsidiaryAdjust | Non-Identifying | One To Zero or More | Fk_SaStudSubsidiaryAdjust_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaSubsidiaryRefund | Non-Identifying | One To Zero or More | Fk_SaSubsidiaryRefund_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaTransCourse | Non-Identifying | One To Zero or More | FK_SaTransCourse_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SaTransCourseAmount | Non-Identifying | Zero or One to Zero or More | FK_SaTransCourseAmount_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SsStudHousingInfo | Identifying | One To Zero or More | FK_SsStudHousingInfo_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SsStudRoommate | Identifying | One To Zero or More | FK_SsStudRoommate_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SyAdvisorByEnroll | Identifying | One To Zero or More | FK_SyAdvisorByEnroll_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SyAudit_AdEnroll | Non-Identifying | One To Zero or More | FK_SyAudit_AdEnroll_RecordID_AdEnroll_AdEnrollID |  |  |  | NO | YES
SyStudentNI | Non-Identifying | One To Zero or More | FK_SyStudentNI_AdEnrollID_AdEnroll_AdEnrollID |  |  |  | NO | YES

AdEnroll Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdEnroll_GradDate | ([Applicant] = 1 or [Applicant] = 0 and [GradDate] is not null)

AdEnroll Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AdEnroll Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentEnrollmentPeriod | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdEnroll | NO |  |  |

AdEnroll Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Addresses_Affiliations
Logical | Applicant_Enroll
Logical | CourseRegistration
Logical | DegreePathway
Logical | Documents
Logical | Grades/Attendance
Logical | LedgerCard_Billing
Logical | RefundCalculation
Logical | Refunds_Stipends
Logical | Revenue_GL_BankDeposit
Logical | SEVIS
Logical | StudentEnrollment
Logical | StudentJobPlacement
Logical | StudentPayments_Collections
Logical | StudentPlacementPreferences
Logical | SubsidiaryLedger
Logical | Tasks
Logical | TestScores
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdEnroll Data Movement Rules

Name | Type | Rule Text/Value